package com.sy.dao;


import com.sy.entity.Smslog;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;


public interface SmslogDao {
    /*新增*/
    @Insert("insert into t_smslog (id,phone,flag,content,ctime) values(#{id},#{phone},#{flag},#{content},#{ctime})")
    int insert(Smslog smslog);
    @Insert("insert into t_smslog (phone,flag,content,ctime) values(#{phone},#{flag},#{content},now())")
    int insertSms(Smslog smslog);
    /*删除*/
    @Delete("delete from t_smslog where id=#{id}")
    int deleteById(int id);
    /*查询全部*/
    @Select("select * from t_smslog")
    List<Smslog> all();
}